CREATE EXTERNAL TABLE jms_dm.dm_service_site_out_brand_cooperate_company_agg_dt(
 `site_in_date` date COMMENT '入库日期',
 `province` string COMMENT '省份',
 `city` string COMMENT '城市',
 `area` string COMMENT '区',
 `expresscompanycode` string COMMENT '快递公司编码',
 `site_in_cnt` bigint COMMENT '入库量',
 `site_out_cnt` bigint COMMENT '出库量',
 `site_abnormal_out_cnt` bigint COMMENT '异常出库量',
 `site_current_out_cnt` bigint COMMENT '当日出库量',
 `site_current_end_cnt` bigint COMMENT '当日完结量',
 `site_t1_out_cnt` bigint COMMENT 'T+1日出库量',
 `site_t1_end_cnt` bigint COMMENT 'T+1日完结量',
 `site_t3_out_cnt` bigint COMMENT 'T+3日出库量',
 `site_t3_end_cnt` bigint COMMENT 'T+3日完结量',
 `site_t6_out_cnt` bigint COMMENT 'T+6日出库量',
 `site_t6_end_cnt` bigint COMMENT 'T+6日完结量',
 `agency_code` string COMMENT '代理区code',
 `agency_name` string COMMENT '代理区名字',
 `province_code` string COMMENT '省code',
 `city_code` string COMMENT '城市code',
 `area_code` string COMMENT '区code',
 servicesitecode string comment '服务点code' ,
 servicesitename string comment '服务点' ,
cooperate_company string comment '合作公司'
  )
COMMENT '百世出入库统计网点品牌合作公司汇总报表'
PARTITIONED BY (
  `dt` string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_service_site_out_brand_cooperate_company_agg_dt'
TBLPROPERTIES (
'discover.partitions' = 'false',
 'parquet.column.index.access' = 'true'
);




